Need help with converting number to alphacol ID

[welchs101]

Hi,

I have a function (see below) which converts a "number" to an alphacol ID.

For example: Number =1 then alphacol(1) = "A"

However, this function only works from 1 to 256................any idea on how to fix this or get a new function?

Please Login or Register  to view this content.

[AB33]

There are only 255 chr in ASCII, unless you are looking for something else.

[Winon]

Hello welchs101,

As AB33 summised(

...unless you are looking for something else.

Could you please attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Regards.

[welchs101]

well, what i need is for example something that does the following:

Note: in current versions of excel one can have more than 256 cols of data

So what i need is if i submit alphacol(400) then i need the corresponding alpha-col from this. For example: if alphacol(3) = C

does this make sense?

[Winon]

Hello welchs101,

See if this link is of any help: https://support.microsoft.com/en-us/kb/272729

Regards.

[welchs101]

see enclosed file.


what i need is a function that when given a number returns the alpha value

for example: if number is 651 then character col value returned is "YA"

see enclosed file.

[Olly]

Why do you need the column letter(s)? You can just use the column number to refer to a range...?

[Olly]

If you insist, though, then try:

Please Login or Register  to view this content.

[AB33]

From stack flaw

Please Login or Register  to view this content.

[welchs101]

thanks all.